home *** CD-ROM | disk | FTP | other *** search
/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 1407 < prev    next >
Unknown  |  1998-01-30  |  441 b 
open in: MacOS 8.1     |     Win98     |     DOS

view JSON data     |     view as text


This file was not able to be converted.
This format is not currently supported by dexvert.

ConfidenceProgramDetectionMatch TypeSupport
100% file data default
100% disktype Blank disk/medium default (weak)


hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 49 4e | 53 45 52 54 20 52 45 53 |CHILD IN|SERT RES|
|00000010| 54 52 49 43 54 00 20 20 | 20 20 2d 2d 20 45 52 77 |TRICT.  |  -- ERw|
|00000020| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00000030| 74 69 6d 65 0d 0a 20 20 | 20 20 2d 2d 20 25 50 61 |time..  |  -- %Pa|
|00000040| 72 65 6e 74 20 25 56 65 | 72 62 50 68 72 61 73 65 |rent %Ve|rbPhrase|
|00000050| 20 25 43 68 69 6c 64 20 | 4f 4e 20 43 48 49 4c 44 | %Child |ON CHILD|
|00000060| 20 49 4e 53 45 52 54 20 | 52 45 53 54 52 49 43 54 | INSERT |RESTRICT|
|00000070| 20 0d 0a 20 20 20 20 77 | 68 65 6e 20 28 0d 0a 20 | ..    w|hen (.. |
|00000080| 20 20 20 20 20 2d 2d 20 | 25 25 4e 6f 74 6e 75 6c |     -- |%%Notnul|
|00000090| 6c 46 4b 28 25 43 68 69 | 6c 64 2c 22 20 69 73 20 |lFK(%Chi|ld," is |
|000000a0| 6e 6f 74 20 6e 75 6c 6c | 20 61 6e 64 22 29 20 0d |not null| and") .|
|000000b0| 0a 20 20 20 20 20 20 25 | 4e 6f 74 6e 75 6c 6c 46 |.      %|NotnullF|
|000000c0| 4b 28 25 43 68 69 6c 64 | 2c 22 20 69 73 20 6e 6f |K(%Child|," is no|
|000000d0| 74 20 6e 75 6c 6c 20 61 | 6e 64 22 29 0d 0a 20 20 |t null a|nd")..  |
|000000e0| 20 20 20 20 6e 6f 74 20 | 65 78 69 73 74 73 20 28 |    not |exists (|
|000000f0| 0d 0a 20 20 20 20 20 20 | 20 20 73 65 6c 65 63 74 |..      |  select|
|00000100| 20 2a 20 66 72 6f 6d 20 | 25 50 61 72 65 6e 74 0d | * from |%Parent.|
|00000110| 0a 20 20 20 20 20 20 20 | 20 77 68 65 72 65 0d 0a |.       | where..|
|00000120| 20 20 20 20 20 20 20 20 | 20 20 2d 2d 20 25 25 4a |        |  -- %%J|
|00000130| 6f 69 6e 46 4b 50 4b 28 | 25 43 68 69 6c 64 2c 25 |oinFKPK(|%Child,%|
|00000140| 50 61 72 65 6e 74 2c 22 | 20 3d 20 22 2c 22 20 61 |Parent,"| = "," a|
|00000150| 6e 64 22 29 20 0d 0a 20 | 20 20 20 20 20 20 20 20 |nd") .. |        |
|00000160| 20 25 4a 6f 69 6e 46 4b | 50 4b 28 25 43 68 69 6c | %JoinFK|PK(%Chil|
|00000170| 64 2c 25 50 61 72 65 6e | 74 2c 22 20 3d 20 22 2c |d,%Paren|t," = ",|
|00000180| 22 20 61 6e 64 22 29 0d | 0a 20 20 20 20 20 20 29 |" and").|.      )|
|00000190| 0d 0a 20 20 20 20 29 0d | 0a 20 20 20 20 20 20 20 |..    ).|.       |
|000001a0| 28 65 72 72 6f 72 29 20 | 66 6f 72 20 65 61 63 68 |(error) |for each|
|000001b0| 20 72 6f 77 0d 0a 00 18 | 27                      | row....|'       |
+--------+-------------------------+-------------------------+--------+--------+